/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 10:55:01
*/


-- ----------------------------
-- Table structure for tb0001
-- ----------------------------
DROP TABLE [dbo].[tb0001]
GO
CREATE TABLE [dbo].[tb0001] (
[CompanyName] nvarchar(100) NULL ,
[ShortName] nvarchar(50) NULL ,
[Tel] nvarchar(50) NULL ,
[Fax] nvarchar(50) NULL ,
[Email] nvarchar(50) NULL ,
[Address] nvarchar(250) NULL ,
[CountryID] varchar(20) NULL ,
[CityID] varchar(20) NULL ,
[ChiefAccountant] nvarchar(50) NULL ,
[Director] nvarchar(50) NULL ,
[Chairmain] nvarchar(50) NULL ,
[BaseCurrencyID] varchar(20) NULL ,
[PeriodNum] int NULL ,
[DBID] varchar(2) NULL ,
[QuantityDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[UnitCostDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[ConvertedDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[DBVersion] nvarchar(20) NULL ,
[CurrencyID] varchar(20) NULL ,
[Serial] nvarchar(50) NULL ,
[InvoiceNo] nvarchar(50) NULL 
)


GO

-- ----------------------------
-- Records of tb0001
-- ----------------------------
INSERT INTO [dbo].[tb0001] ([CompanyName], [ShortName], [Tel], [Fax], [Email], [Address], [CountryID], [CityID], [ChiefAccountant], [Director], [Chairmain], [BaseCurrencyID], [PeriodNum], [DBID], [QuantityDecimals], [UnitCostDecimals], [ConvertedDecimals], [DBVersion], [CurrencyID], [Serial], [InvoiceNo]) VALUES (N'CTY ', N'', N'', N'', N'', N'', N'VN', N'03', N'', N'', N'', N'VND', N'12', N'A', N'0', N'0', N'0', N'5.00.00', null, N'', N'')
GO
GO
